| Widget Heading
|
Widget Heading
|
| TableID
|
TableID is a link to the Report
Table Editor. If you have a table that you want to re-use, then enter the ID.
For new widgets, this will be blank; once the table has been configured and
saved, the ID will be displayed in this box. If the TableID has a value, then
clicking on the TableID will take you to the Report Table Editor for this
table. When the TableID is blank, clicking on the TableID will take you a new
blank Report Table Editor.
|
| Footer Text
|
Text that appears at the bottom
of the widget.
|
| Filter1
|
See Filter section below table.
|
| Fillter2
|
See Filter section below table.
|
| Filter3
|
See Filter section below table.
|
| FuncFilter
|
The name of a function, used
only when creating a table from a view. The view will return the column names
selected from the function, but the function will allow parameters to be passed
down to it, such as time periods and user/org details. The function also allows
more complex querying to take place as there are some restrictions on a view.
In general, this feature is only used when working with Bentley Support to
configure/set up the system.
|
| Include Header
|
Enter the name of a web file
(such as alarmbanner.jsp) that will display above your table within the live
Custom Table widget.
|
| Refresh Period
|
Drop-down choice of: No Refresh,
15 seconds, 30 seconds, 1 minute, 5 minutes, 10 minutes, 1 hour. The widget
will reload as frequently as the refresh period dictates. Defaults to 0 (no
refresh) if no choice is selected.
|
| Override Period
|
Drop-down choice of: Disabled
Last 24 Hours, Last 48 Hours, Current Month, Current Year. Defaults to Disabled
if no choice is selected. If disabled, then the widget uses the period selector
above the dashboard to specify what period of data to display. If you wish to
only show data from a certain period, you can select one of these options.
Choosing Current Month for example, means if there is data for the current
month, it will display, else the cell will be blank. This setting is not to be
used with "Reset Start Date".
|
| Show Historical Data
|
Drop-down choice of: No, Yes - Up to 2 years, Yes
- Last Value.
Defaults to No if no choice is selected.
- Yes - Up to 2
years, this changes the default period to look back for data, from the current
year to the previous year.
- Yes - Last Value,
this returns the last value, regardless of period.
This would override the dashboard period selector.
Not to be used with "Override Period".
|
| Render Type
|
Interactive gives headers that can be clicked on
and sorted, along with filter text boxes in the header.
Interactive mode also allows users to edit
'Attribute' cells only. All other cells will not be editable. This editable
feature applies to Fixed and Iterative tables only - it will not be available
when using a view.
A user group permission 'Edit Custom Table Cells'
has been added. Tables can still be set to interactive, but no cells will be
editable unless this permission has been set.
A value is auto-saved when leaving the cell. When
a value is saved, it updates the value in the properties link table with the
current timestamp - regardless of whether the user has selected a different
time period. So to see the change, the user will have to select the current
month/week/day depending on period selector active.
It is also still editable within a Report, but the
same applies with the timestamp on the update.
|
